lyfz_repos/铂金版源码/DBFile/SQL/2015-08-13[收集]/2015-09-24(腾工).sql

if not exists
(select * from syscolumns where id=object_id('tb_ErpOrderProductList') and name='OPlist_Batch')
begin
	alter table tb_ErpOrderProductList add OPlist_Batch  nvarchar(10) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpOrderProductList', N'COLUMN',N'OPlist_Batch'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÉÌÆ·µ¥Î»' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpOrderProductList', @level2type=N'COLUMN',@level2name=N'OPlist_Batch'
GO

if not exists
(select * from syscolumns where id=object_id('tb_ErpWeddingService') and name='Ws_Unit')
begin
	alter table tb_ErpWeddingService add Ws_Unit  nvarchar(10) NULL
end
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'tb_ErpWeddingService', N'COLUMN',N'Ws_Unit'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·þÎñµ¥Î»' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpWeddingService', @level2type=N'COLUMN',@level2name=N'Ws_Unit'
GO